USE [comunion]
GO

/****** Object:  StoredProcedure [dbo].[rsp_Transaction_WRR]    Script Date: 06/18/2010 15:51:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





--exec rsp_Transaction_PurchaseInvoice 'RR-100001','000-00'

--Stored Procedure for Transactional Printout (Warehouse Receiving Report)
CREATE  PROCEDURE [dbo].[rsp_Transaction_PurchaseInvoice]
	@cTranNo VARCHAR(25),
	@cCompID VARCHAR(10)

AS 

	SELECT A.cTranNo, A.dDate, A.cCode, B.cName, A.nGross, A.cRemarks
	FROM PURCHASE A 
	LEFT OUTER JOIN CLIENT_SUPPLIER B ON A.cCode = B.cCode AND A.cCompanyID = B.cCompanyID
	WHERE A.cTranNo = @cTranNo AND A.cCompanyID = @cCompID
	





 

GO


